
//-------------------------
// Legislators as Lobbyists
// TABLE A4
//-------------------------

clear
use masterdata_taa.dta

by year, sort: egen totpetition = count(certified)
by year, sort: egen totapproved = sum(certified)
gen approved = totapproved/totpetition
by year, sort: gen tt = 1 if _n == 1
br year totpetition approved if tt == 1
